<!DOCTYPE html>
<html>
<head>
<title>readme</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<style type="text/css">
/* GitHub stylesheet for MarkdownPad (http://markdownpad.com) */
/* Author: Nicolas Hery - http://nicolashery.com */
/* Version: b13fe65ca28d2e568c6ed5d7f06581183df8f2ff */
/* Source: https://github.com/nicolahery/markdownpad-github */

/* RESET
=============================================================================*/

html, body, div, span, applet, object, iframe, h1, h2, h3, h4, h5, h6, p, blockquote, pre, a, abbr, acronym, address, big, cite, code, del, dfn, em, img, ins, kbd, q, s, samp, small, strike, strong, sub, sup, tt, var, b, u, i, center, dl, dt, dd, ol, ul, li, fieldset, form, label, legend, table, caption, tbody, tfoot, thead, tr, th, td, article, aside, canvas, details, embed, figure, figcaption, footer, header, hgroup, menu, nav, output, ruby, section, summary, time, mark, audio, video {
  margin: 0;
  padding: 0;
  border: 0;
}

/* BODY
=============================================================================*/

body {
  font-family: Helvetica, arial, freesans, clean, sans-serif;
  font-size: 14px;
  line-height: 1.6;
  color: #333;
  background-color: #fff;
  padding: 20px;
  max-width: 960px;
  margin: 0 auto;
}

body>*:first-child {
  margin-top: 0 !important;
}

body>*:last-child {
  margin-bottom: 0 !important;
}

/* BLOCKS
=============================================================================*/

p, blockquote, ul, ol, dl, table, pre {
  margin: 15px 0;
}

/* HEADERS
=============================================================================*/

h1, h2, h3, h4, h5, h6 {
  margin: 20px 0 10px;
  padding: 0;
  font-weight: bold;
  -webkit-font-smoothing: antialiased;
}

h1 tt, h1 code, h2 tt, h2 code, h3 tt, h3 code, h4 tt, h4 code, h5 tt, h5 code, h6 tt, h6 code {
  font-size: inherit;
}

h1 {
  font-size: 28px;
  color: #000;
}

h2 {
  font-size: 24px;
  border-bottom: 1px solid #ccc;
  color: #000;
}

h3 {
  font-size: 18px;
}

h4 {
  font-size: 16px;
}

h5 {
  font-size: 14px;
}

h6 {
  color: #777;
  font-size: 14px;
}

body>h2:first-child, body>h1:first-child, body>h1:first-child+h2, body>h3:first-child, body>h4:first-child, body>h5:first-child, body>h6:first-child {
  margin-top: 0;
  padding-top: 0;
}

a:first-child h1, a:first-child h2, a:first-child h3, a:first-child h4, a:first-child h5, a:first-child h6 {
  margin-top: 0;
  padding-top: 0;
}

h1+p, h2+p, h3+p, h4+p, h5+p, h6+p {
  margin-top: 10px;
}

/* LINKS
=============================================================================*/

a {
  color: #4183C4;
  text-decoration: none;
}

a:hover {
  text-decoration: underline;
}

/* LISTS
=============================================================================*/

ul, ol {
  padding-left: 30px;
}

ul li > :first-child, 
ol li > :first-child, 
ul li ul:first-of-type, 
ol li ol:first-of-type, 
ul li ol:first-of-type, 
ol li ul:first-of-type {
  margin-top: 0px;
}

ul ul, ul ol, ol ol, ol ul {
  margin-bottom: 0;
}

dl {
  padding: 0;
}

dl dt {
  font-size: 14px;
  font-weight: bold;
  font-style: italic;
  padding: 0;
  margin: 15px 0 5px;
}

dl dt:first-child {
  padding: 0;
}

dl dt>:first-child {
  margin-top: 0px;
}

dl dt>:last-child {
  margin-bottom: 0px;
}

dl dd {
  margin: 0 0 15px;
  padding: 0 15px;
}

dl dd>:first-child {
  margin-top: 0px;
}

dl dd>:last-child {
  margin-bottom: 0px;
}

/* CODE
=============================================================================*/

pre, code, tt {
  font-size: 12px;
  font-family: Consolas, "Liberation Mono", Courier, monospace;
}

code, tt {
  margin: 0 0px;
  padding: 0px 0px;
  white-space: nowrap;
  border: 1px solid #eaeaea;
  background-color: #f8f8f8;
  border-radius: 3px;
}

pre>code {
  margin: 0;
  padding: 0;
  white-space: pre;
  border: none;
  background: transparent;
}

pre {
  background-color: #f8f8f8;
  border: 1px solid #ccc;
  font-size: 13px;
  line-height: 19px;
  overflow: auto;
  padding: 6px 10px;
  border-radius: 3px;
}

pre code, pre tt {
  background-color: transparent;
  border: none;
}

kbd {
    -moz-border-bottom-colors: none;
    -moz-border-left-colors: none;
    -moz-border-right-colors: none;
    -moz-border-top-colors: none;
    background-color: #DDDDDD;
    background-image: linear-gradient(#F1F1F1, #DDDDDD);
    background-repeat: repeat-x;
    border-color: #DDDDDD #CCCCCC #CCCCCC #DDDDDD;
    border-image: none;
    border-radius: 2px 2px 2px 2px;
    border-style: solid;
    border-width: 1px;
    font-family: "Helvetica Neue",Helvetica,Arial,sans-serif;
    line-height: 10px;
    padding: 1px 4px;
}

/* QUOTES
=============================================================================*/

blockquote {
  border-left: 4px solid #DDD;
  padding: 0 15px;
  color: #777;
}

blockquote>:first-child {
  margin-top: 0px;
}

blockquote>:last-child {
  margin-bottom: 0px;
}

/* HORIZONTAL RULES
=============================================================================*/

hr {
  clear: both;
  margin: 15px 0;
  height: 0px;
  overflow: hidden;
  border: none;
  background: transparent;
  border-bottom: 4px solid #ddd;
  padding: 0;
}

/* TABLES
=============================================================================*/

table th {
  font-weight: bold;
}

table th, table td {
  border: 1px solid #ccc;
  padding: 6px 13px;
}

table tr {
  border-top: 1px solid #ccc;
  background-color: #fff;
}

table tr:nth-child(2n) {
  background-color: #f8f8f8;
}

/* IMAGES
=============================================================================*/

img {
  max-width: 100%
}
</style>
</head>
<body>
<h1>Mbatis-Plus 使用文档</h1>
<blockquote>
<p>更多文档查看 /mybatis-plus/src/test/resources/wiki</p>
</blockquote>
<h2>一、插入</h2>
<p>1、插入一条（id 如果不传入会自动生成）</p>
<pre><code>long id = IdWorker.getId();
int rlt = userMapper.insert(new User(id, &quot;abc&quot;, 18, 0));
</code></pre>

<p>2、插入一条记录（选择字段， null 字段不插入）</p>
<pre><code>int rlt = userMapper.insertSelective(new User(&quot;abc&quot;, 18));
</code></pre>

<p>3、批量插入</p>
<pre><code>List&lt;User&gt; ul = new ArrayList&lt;User&gt;();
//手动输入 ID
ul.add(new User(11L, &quot;1&quot;, 1, 0));
ul.add(new User(12L, &quot;2&quot;, 2, 1));
ul.add(new User(13L, &quot;3&quot;, 3, 1));
ul.add(new User(14L, &quot;delname&quot;, 4, 0));
ul.add(new User(15L, &quot;5&quot;, 5, 1));
ul.add(new User(16L, &quot;6&quot;, 6, 0));
ul.add(new User(17L, &quot;7&quot;, 7, 0));
//使用 ID_WORKER 自动生成 ID
ul.add(new User(&quot;8&quot;, 8, 1));
ul.add(new User(&quot;9&quot;, 9, 1));
rlt = userMapper.insertBatch(ul);
</code></pre>

<h2>二、删除</h2>
<p>1、删除一条</p>
<pre><code>int rlt = userMapper.deleteById(id);
</code></pre>

<p>2、批量删除</p>
<pre><code>List&lt;Long&gt; il = new ArrayList&lt;Long&gt;();
il.add(16L);
il.add(17L);
int rlt = userMapper.deleteBatchIds(il);
</code></pre>

<p>3、按照条件删除</p>
<pre><code>int rlt = userMapper.deleteSelective(new User(14L, &quot;delname&quot;));
</code></pre>

<h2>三、修改</h2>
<p>1、修改</p>
<pre><code>int rlt = userMapper.updateById(new User(12L, &quot;MybatisPlus&quot;));
</code></pre>

<p>2、根据 ID 选择修改</p>
<pre><code>int rlt = userMapper.updateSelectiveById(new User(12L, &quot;MybatisPlus&quot;));
</code></pre>

<p>3、根据 whereEntity 条件，更新记录（支持 null 查询无条件更新）</p>
<pre><code>int rlt = userMapper.update(new User(&quot;55&quot;, 55, 5), new User(15L, &quot;5&quot;));
</code></pre>

<p>4、根据 whereEntity 条件，选择更新记录（支持 null 查询无条件更新）</p>
<pre><code>int rlt = userMapper.updateSelective(new User(&quot;00&quot;), new User(15L, &quot;55&quot;));
</code></pre>

<p>5、根据ID 批量更新</p>
<pre><code>List&lt;User&gt; userList = new ArrayList&lt;User&gt;();
userList.add(new User(11L, &quot;updateBatchById-1&quot;, 1, 1));
userList.add(new User(12L, &quot;updateBatchById-2&quot;, 2, 2));
userList.add(new User(13L, &quot;updateBatchById-3&quot;, 3, 3));
int rlt = userMapper.updateBatchById(userList);
</code></pre>

<h2>四、查询</h2>
<p>1、根据ID查询</p>
<pre><code>User user = userMapper.selectById(12L);
</code></pre>

<p>2、根据ID批量查询</p>
<pre><code>List&lt;Long&gt; idList = new ArrayList&lt;Long&gt;();
idList.add(11L);
idList.add(12L);
List&lt;User&gt; ul1 = userMapper.selectBatchIds(idList);
</code></pre>

<p>3、根据条件查询</p>
<pre><code>User userOne = userMapper.selectOne(new User(&quot;MybatisPlus&quot;));
</code></pre>

<p>4、根据条件查询总记录数（支持 null 查询无条件查询）</p>
<pre><code>int count = userMapper.selectCount(null);
</code></pre>

<p>5、查询列表 id 排序</p>
<pre><code>List&lt;User&gt; ul2 = userMapper.selectList(new EntityWrapper&lt;User&gt;(null, &quot;id DESC&quot;));
</code></pre>

<p>6、翻页查询 id 排序</p>
<pre><code>Page&lt;User&gt; page = new Page&lt;User&gt;(1, 2);
EntityWrapper&lt;User&gt; ew = new EntityWrapper&lt;User&gt;(new User(1), &quot;id DESC&quot;);
List&lt;User&gt; paginList = userMapper.selectPage(page, ew);
page.setRecords(paginList);
for ( int i = 0 ; i &lt; page.getRecords().size() ; i++ ) {
    print(page.getRecords().get(i));
}
</code></pre>


</body>
</html>
<!-- This document was created with MarkdownPad, the Markdown editor for Windows (http://markdownpad.com) -->
